[PRAGMA synchronous | Query or change the setting of the "synchronous" flag affecting the database for the duration of the current database connection.]
PRAGMA synchronous| = FULL | NORMAL | OFF;
[PRAGMA temp_store | Query or change the setting of the "temp_store" flag affecting the database for the duration of the current database connection. ]
PRAGMA temp_store| = DEFAULT | MEMORY | FILE;
[PRAGMA database_list | For each open database, invoke the callback function once with information about that database.]
PRAGMA database_list;|
[PRAGMA foreign_key_list(table-name) | For each foreign key invoke the callback function with information about that foreign key.]
PRAGMA foreign_key_list(|table-name);
[PRAGMA index_info(index-name) | For each column that the named index references, invoke the callback function once with information about that column.]
PRAGMA index_info(|index-name);
[PRAGMA index_list(table-name) | For each index on the named table, invoke the callback function once with information about that index.]
PRAGMA index_list(|table-name);
[PRAGMA table_info(table-name) | For each column in the named table, invoke the callback function once with information about that column.]
PRAGMA table_info(|table-name);
[PRAGMA database.schema_cookie | The pragmas schema_cookie and user_cookie are used to set or get the value of the schema-cookie.]
PRAGMA [database.]schema_cookie| = integer ;
PRAGMA [database.]user_cookie| = integer ;
[PRAGMA integrity_check | The command does an integrity check of the entire database.]
PRAGMA integrity_check;|
[PRAGMA parser_trace | Turn tracing of the SQL parser inside of the SQLite library on and off.]
PRAGMA parser_trace = ON|OFF;
[PRAGMA vdbe_trace | Turn tracing of the virtual database engine inside of the SQLite library on and off.]
